SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Updates a record in the Setting table
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.Setting_Update
(

	@SettingName nvarchar (50)  ,

	@OriginalSettingName nvarchar (50)  ,

	@SettingValue nvarchar (50)  ,

	@DataType nchar (10)  ,

	@Description nchar (10)  
)
AS


				
				
				-- Modify the updatable columns
				UPDATE
					[dbo].[Setting]
				SET
					[SettingName] = @SettingName
					,[SettingValue] = @SettingValue
					,[DataType] = @DataType
					,[Description] = @Description
				WHERE
[SettingName] = @OriginalSettingName 
				
			

GO
